how to declare a global connection in database that will be called in all other form modules rather than explicitly defining the connection everytime when separate form module is loaded.

ANSWER FAST PLS!

Diptiman Basak

if it's in .net.
then creating a class will be better.

I know in .NET its possible. but won't it be possible in VB 6.0?

in vb 6

Declare in a module and you can call it anywhere in your program

Public conn1 as adodb.connection

create
public function openconn()
on error goto errConn
strConn= your connection string
set conn1=new adodb.connection
conn1.connectionstring=strConn
conn1.open

exit function
errConn:
end function

this can be called anywhere
if conn1.state=adstateopen then
conn1.execute(your SQL to execute)
end if

HTH