Ayyuka ConnectionString

Tafara da Wasa

Ayyuka ConnectionString za ta za ayyuka ko tasi ko yiwa ko tasi ko ayyuka bayanin saman saman da ke ayyuka data source.

Shirin:A ka ko yiya ayyuka Provider da ayyuka File Name garga a kai kai kai yiwa.

Girmama

objconn.ConnectionString="para1=value;para2=value;etc;"

Ayyuka ConnectionString ta da ke aya 5 garga:

Parameter Description
Provider The name of the provider used for the connection.
File Name The name of the provider-specific file (for example, a persistent data source object) that contains preset connection information.
Remote Provider The name of the provider used when opening a client connection. (Limited to Remote Data Services only.)
Remote Server The path name of the server used when opening a client connection. (Limited to Remote Data Services only.)
url Absolute URL that identifies a resource (such as a file or directory).

Example

<%
set conn=Server.CreateObject("ADODB.Connection") 
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0"
conn.open server.mappath("database.mdb")
conn.close
%>