NEW ADO CONNECTION

[IrinaK]

This doesn't work:
cn.Open "Provider=MSDASQL.1;Persist Security Info=False;Data Source=N:\applications\ownhist.dsn;"
What's wrong?
I received Error massage:
Data source name not found.

Thank you.

 

[woyler]

What kind of DSN are you trying to use?(user,system,file)
Is the drive 'N:\' local to you or is it a mapped drive?

 

[IrinaK]

I am trying to use file DSN.
N drive is not local, it's network.

 

[polash]

after creating file dsn you should use ADODC. then try to connect with that dsn through adodc properties. If connection eshtalished properly then you get the string in a text box of the connection. Copy it and place it after cn.open. I hope you get the solution.

 

[woyler]

Make sure that you are using the same drivers(specified in your code, and in the DSN)This is required for a file DSN

 

[IrinaK]

Thanks to everybody.
It works!!!!!!!!!!!!!